Error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query |
Article ID: 126 |
 Back to Search
|
When you attempt to write data via an update or insert to a MS Access database, you receive the following error in your web browser:
Error:
"Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/somepath/mywebpage.asp, line n "
Cause:
The database does not have write permissions by the IUSR_ account for your domain
OR
You have uploaded your .MDB file as 'read only'
Resolution:
1. Verify that when you uploaded your file it was not marked as read-only. If it is, uncheck it and re-upload the .mdb. To see if the file is read-only, right click the .mdb and look for the read-only check box.
2. Verify that IUSR has write permissions for the .MDB file.
Here's how:
a. Login to PLESK
b. Click your domain name
c. Click the File Manager icon
d. Click the httpdocs folder
e. Locate the folder that contains your .MDB file, then click the lock icon that is located to the right of the folder
f. Click the create files check box that is associated with the IUSR account for your domain. Then click the OK button.
g. Now click the link for the folder that contains the .MDB file.
h. Click the lock icon next to your .MDB file.
i. Click the check box for Write Files, next to the IUSR_ account and then click ok.
You should now be able to update your data for your .MDB file via a web page. |
| |
| Downloads Associated With This Article |
| No downloads are currently associated with this article. |
KB
